Suppose we are given the following dataset around monthly revenue and expenses:
There are many ways to visualize this data. For example, we could use the columns Month, Revenue, and Expense to summarize the expenses and revenue by month, and plot the relationship between expenses and revenue:
Is there any useful information we can glean from looking at the above chart?
We can also create another scatterplot using the columns Fund, Revenue, and Expense. Again we’ll look at the relationship between revenue and expenses, but this time we’ll color the data points by the type of fund they belong to:
What kinds of additional new insights can we gain from the data by visualizing it via the above chart?
Next, let’s create a bar chart using the columns Fund, Revenue, and Expense, where the bars represent the total revenue and expenses for the year, and the chart is grouped by the different funds:
What new questions might we have after visualizing the data in the above chart?
Lastly, we can visualize the data as a time series, by plotting lines representing the revenue and expenses by date, and breaking the data into three charts representing the different funds:
What final questions might we have after visualizing the data in the above three charts?